﻿CREATE TABLE [transaction].[TransactionItem] (
    [TransactionItemID] INT           IDENTITY (1, 1) NOT NULL,
    [TransactionTypeID] INT           NULL,
    [Item]              VARCHAR (500) NULL,
    [CreatedBy]         VARCHAR (50)  NULL,
    [CreatedDate]       DATETIME      NULL,
    [UpdatedBy]         VARCHAR (50)  NULL,
    [UpdatedDate]       DATETIME      NULL,
    [EndDate]           DATETIME      NULL,
    CONSTRAINT [PK_TransactionItem] PRIMARY KEY CLUSTERED ([TransactionItemID] ASC),
    CONSTRAINT [FK_TransactionItem_TransactionType] FOREIGN KEY ([TransactionTypeID]) REFERENCES [transaction].[TransactionType] ([TransactionTypeID])
);

